/*
Navicat MySQL Data Transfer

Source Server         : mysql8g
Source Server Version : 80018
Source Host           : localhost:3306
Source Database       : stu_add_score

Target Server Type    : MYSQL
Target Server Version : 80018
File Encoding         : 65001

Date: 2021-09-12 20:33:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for demo_batch
-- ----------------------------
DROP TABLE IF EXISTS `demo_batch`;
CREATE TABLE `demo_batch` (
`id`  bigint(20) NOT NULL ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`content`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`create_time`  datetime NULL DEFAULT NULL ,
`update_time`  datetime NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of demo_batch
-- ----------------------------
BEGIN;
INSERT INTO `demo_batch` VALUES ('1', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('2', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('3', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('4', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('5', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('6', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('7', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('8', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('9', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('10', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('11', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('12', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('13', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('14', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('15', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('16', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('17', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('18', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('19', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('20', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('21', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('22', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('23', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('24', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('25', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('26', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('27', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('28', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('29', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('30', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('31', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('32', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('33', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('34', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('35', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('36', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('37', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('38', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('39', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('40', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('41', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('42', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('43', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('44', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('45', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('46', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('47', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('48', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('49', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('50', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('51', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('52', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('53', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('54', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('55', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('56', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('57', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('58', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('59', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('60', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('61', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('62', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('63', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('64', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('65', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('66', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('67', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('68', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('69', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('70', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('71', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('72', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('73', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('74', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('75', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('76', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('77', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('78', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('79', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('80', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('81', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('82', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('83', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('84', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('85', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('86', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('87', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('88', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('89', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('90', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('91', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('92', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('93', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('94', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('95', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('96', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('97', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('98', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('99', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35'), ('100', 'aaa', 'bbb', '2021-09-12 17:08:35', '2021-09-12 17:08:35');
COMMIT;

-- ----------------------------
-- Table structure for stu_class
-- ----------------------------
DROP TABLE IF EXISTS `stu_class`;
CREATE TABLE `stu_class` (
`id`  int(11) NULL DEFAULT NULL ,
`class_name`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of stu_class
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`class_id`  int(11) NULL DEFAULT NULL ,
`score`  int(11) NULL DEFAULT NULL ,
`class_name`  varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Auto increment value for student
-- ----------------------------
ALTER TABLE `student` AUTO_INCREMENT=1;
